﻿
////////////////////////////////////////////////////////////////////////////////////////////
// 文件名: ETL_Source_ViewConfigInfo.cs
//
// 模块名称: ETLSourceViewInfo
//
// 作者: lpc
//
// 历史记录（记录修改记录，修改文件后请添加修改记录，注明修改时间、修改人，修改内容）:
// 13-2-5  lpc  创建文件
////////////////////////////////////////////////////////////////////////////////////////////

using System;
using System.Collections.Generic;
using System.Text;

namespace Model
{
    /// <summary>
    /// ETL_Source_ViewConfig表实体类
    /// </summary>
    public class ETL_Source_ViewConfigInfo
    {
        /// <summary>
        /// GUID
        /// </summary>
        public string Guid { get; set; }
        /// <summary>
        /// SourceSystemID
        /// </summary>
        public string SourceSystemID { get; set; }
        /// <summary>
        /// ViewName
        /// </summary>
        public string DBID { get; set; }
        public string WildCardID { get; set; }
        public string ViewName { get; set; }
        /// <summary>
        /// ViewChnName
        /// </summary>
        public string ViewChnName { get; set; }
        /// <summary>
        /// CreateTableScript
        /// </summary>
        public string CreateTableScript { get; set; }

        public int StepStatus { get; set; }
        public int IsDistinct { get; set; }
        public string CreateUser { get; set; }
         
        public DateTime CreateTime { get; set; }
         
        public string UpdateUser { get; set; }
         
        public DateTime UpdateTime { get; set; }
         
        public string DeleteUser { get; set; }
         
        public DateTime DeleteTime { get; set; }
         
        public int IsDelete { get; set; }

        public string MDP_ViewSchema { get; set; }

        public string MDP_ViewName { get; set; }

        /// <summary>
        /// 显示名称
        /// </summary>
        public string DisplayName { get; set; }
        /// <summary>
        /// 表模式
        /// </summary>
        public int TableMode { get; set; } 

        /// <summary>
        /// 格式
        /// 1 带分隔符
        /// 2 固定宽度
        /// 3 右边未对齐
        /// </summary>
        public string FileFormat { get; set; }
        /// <summary>
        /// 文本限定符
        /// 缺省：<无>
        /// </summary>
        public string TextQualifier { get; set; }
        /// <summary>
        /// 行分隔符
        /// value="{CR}{LF}"    {CR}{LF}
        /// value="{CR}"        {CR}
        /// value="{LF}"        {LF}
        /// value=";"   分号 {;}
        /// value=":"   冒号 {:}
        /// value=","   逗号 {,}
        /// value="{t}" 制表符 {t}
        /// value="|"   竖线 {|}
        /// </summary>
        public string LineSeparator { get; set; }
        /// <summary>
        /// 列分隔符
        /// value="{CR}{LF}"    {CR}{LF}
        /// value="{CR}"        {CR}
        /// value="{LF}"        {LF}
        /// value=";"   分号 {;}
        /// value=":"   冒号 {:}
        /// value=","   逗号 {,}
        /// value="{t}" 制表符 {t}
        /// value="|"   竖线 {|}
        /// </summary>
        public string ColumnSeparator { get; set; }
        /// <summary>
        /// 要跳过的标题行数
        /// </summary>
        public int SkipRowNum { get; set; }
        /// <summary>
        /// 要跳过的数据行数
        /// </summary>
        public int SkipDataNum { get; set; } 

        #region 扩展属性

        public int ColumnCount { get; set; }
        public int IsFile { get; set; }
        public string BigDataTag { get; set; }

        #endregion

    }
    public class IncrementRole {

        public string GUID { get; set; }
        public string ViewID { get; set; }
        public string RoleType { get; set; }
        public string DateType { get; set; }
        public string IncrementNum { get; set; }
    }
}